if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[LoginInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[LoginInfo]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[LoginTypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[LoginTypes]
GO

CREATE TABLE [dbo].[LoginInfo] (
	[LoginId] [int] NOT NULL ,
	[LoginName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[EmployeeCode] [int] NOT NULL ,
	[Password] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[LoginType] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Discontinue] [bit] NOT NULL ,
	[RightsString] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[BackDateWorkingAllowed] [bit] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[LoginTypes] (
	[LoginTypeID] [decimal](18, 0) NOT NULL ,
	[TypeName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[RightsString] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL 
) ON [PRIMARY]
GO

----------------------------------------------------------------------------------------------------------------------------------------------------

--------------------	login Types	1. Administrator	2. User

INSERT INTO LoginTypes (LoginTypeID, TypeName, RightsString)
VALUES     (1, 'DahlklvqwdqjwĄbUUl)cZ.ZPL`OXHCS36JJ6851(Tl[?n=SkaB', 'TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTĄFj8=LY+UK5@O^XMNGf><(b^OhSK*>WKf`o\b8h>?pfgHO\()cn=AVI4aD>Ff)(WN:c1\n@qphSCWYp/(*]Qg4PW8LN4JQ9JG@53,QB;0P7N5,^oqPl`eS?;HTqDmcU0.CkHkq7<<HKo.U=]K^AO=`-7m/M]<WFa+c^V;066ql4BE8kP)rbQ=S.W9GffPrkQf(JD3iR4aG.C0dgS4_rJgqX\jobE_aDXpFhCW3UB3ArW>;H(GEbm(h(QF0/*mi16qE]9]hVl\-[eqMlp@AkUb1LBA=TH/8GBFFdWHkirl+mS5GSUG(436ZA;8l*9@\P<cem9e5Ya@YNSmn^/8a@8?GhGRC7/U9a0X+f[lV9CL?8K;oUT;,5J2<@(k,jZr^E+NMAW_0kpkGek7DO:.<NP]1(3bGiVN,' )

--------------------	login Info	1. Admin		2. Co (Rights for only Sales Invoice + Net cash Sales)

INSERT INTO LoginInfo (LoginId, LoginName, EmployeeCode, Password, LoginType, Discontinue, RightsString, BackDateWorkingAllowed)
VALUES     (1, 'dahlkĄDZK8mYj02Z3UqCYWP+`7O5BT),lQMbLp3E2Y?JWK<V:S', 1, 'agdĄPH,E57lUMR*cN-1o', 'DahlklvqwdqjwĄbUUl)cZ.ZPL`OXHCS36JJ6851(Tl[?n=SkaB', 0, 'TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTĄLAo<a-;)]kqS5C84dUHmI/qGccg:@GX.A,nfIq^.2_4h_J[MLJ4lq*K)aU<I<nqMme+APhNHqP^?*RDJQHaPg=?f?n@)C=)rOcb5gDXpPJ4Ah@>o<[a7cKOc\qPCD2fJH1Zb355S.Y*BrHMjmE\AW>2c9jIj.3Gfkq<Q7l25l=h`8Nr3c[.A1D5^4bR(;qfr:N/if;P[=N4n?9e[4^KU,E\OdhI1];.h]hZ5bhGrMKLA,:)C?[EP7r\-F:UW7Z9@V7QhfDd(fAB@98U0O\BRCf:=<1RpNh=@8[:@cJ`XQ;?AWcWe.nl-?RA-[WjMHL<_cK=qGa<doEia)W/G;RSLeh*Akm-Z_7:KX]8:MoEE?kS)5E-bB]k6ZBAq95Zh7Z8I*RRMeZ3@mmoMk^QgVQFUY^?lnO7LV', 1 )

--------------------------------------------------